Structure of database tables (2)

EQUIPMENTS

The main table of EQUIPMENTS. It can have as many sub-tables as needed.

PosId	PosId given by the user. It must be unique or empty.
Status	The editing status of the record: whether it is currently being edited by someone or not.
Revision	Internal revision id.
TypeTbl	Name of the subtype (sub-table, like VESSELS)
System	The name of the assigned system.
MenuItmData	Prefix for the Position Id and lookup key for COMPLOOKUP table.
Description	Description of the equipment. Can be empty. This field is used in the integration to Plant Modeller and must exist.
model_status
model_not_set	If anything else than 0, the object is not in the model.
DmPartCode	The OID of the COS object used in Plant Modeller.
PdObjectId	Unique object ID (OID).
PosIdNull	If PosId is null string, this is not zero. The unique PosId is a combination of PosId, Status and PosIdNull fields.

ARMATURES

The main table of ARMATURES. It can have as many sub-tables as needed.

PosId	PosId given by the user. It must be unique or empty.
Status	The editing status of the record: whether it is currently being edited by someone or not.
Revision	Internal revision ID.
TypeTbl	Name of the subtype (sub-table, like VESSELS)
Pipeline	The name of the pipeline to which the armature belongs.
MenuItmData	Prefix for the Position ID and lookup key for COMPLOOKUP table.
Description	Description of the armature. Can be empty. This field is used in the integration to Plant Modeller and must exist.
model_status
model_not_set
DmPartCode	The OID of the COS object used in Plant Modeller.
PdObjectId	Unique object id (oid).
PosIdNull	If PosId is null string, this is not zero. The unique PosId is a combination of PosId, Status and PosIdNull fields.

Special columns in ARMATURES table are "Spec" and "InsulationSpec". If these are added and the pipeline has more than one specification as optional, the options can be selected for the part itself in the database editor.

Insulation specification can be set as required for the pipeline, and then all armatures inherit the specification automatically. If insulation is optional, it can be set for each pipe run and valve separately.

INSTRUMENTS

The main table of INSTRUMENTS. It can have as many sub-tables as needed.

PosId	PosId given by the user. It must be unique among all the instrument Position IDs or empty.
Status	The editing status of the record: whether it is currently being edited by someone or not.
Revision	Internal revision ID.
TypeTbl	Name of the subtype (sub-table, like VESSELS)
Tag	The name of the instrument tag to which the instrument belongs.
MenuItmData	Combination of attributes defined for Diagram Object Template and lookup key for COMPLOOKUP table.
Location	The location of the instrument: local, control room or local control panel.
MeasuredVar	The measured variable. Usually filled in via the Diagram Object Template.
Modifier	Initial value usually filled in by via Diagram Object Template.
Function	Initial value usually filled in by via Diagram Object Template.
Superscript
Subscript
Description
model_status
model_not_set
DmPartCode
PdObjectId	Unique object ID (OID).
PosIdNull	If PosId is null string, this is not zero. The unique PosId is a combination of PosId, Status and PosIdNull fields.

ReviseObjsOfDg

Stores the information which objects are checked in and in which diagram.

Diagram	OID of the Diagram.
PdObjectId	OID of the object (system, pipeline, tag, equipment, armature, instrument)
NrOfObjects	Number of linked objects in the diagram.

EditObjsOfGd

Stores the information which objects are checked out in which diagram.

Diagram	OID of the Diagram.
PdObjectId	OID of the object (system, pipeline, tag, equipment, armature, instrument)
NrOfObjects	Number of linked objects in the diagram.
EditedInThisDiagram	If positive value, the object is edited in this check out diagram.